Someone needs to go fix the Reader's Rides Spreadsheet

"KusabiSensei - Captain of the Toronto Maple Leafs" (kusabisensei)
12/03/2013 at 11:24 • Filed to: Failopnik

EDIT: That someone was me. You might want to check to make sure your celebrity crush doesn't make certain things apply. Not that there's anything wrong with that...
Only the first 5 columns are sorted, so this leads to very silly things.

Automatch's Mazda3 now has oversize tires, and he has a crush on Jake Gyllenhaal, *and* used to own ALL the same cars I did!

(Note: This is not intended to pick on Automatch, but shows that if you don't sort ALL THE COLUMNS, you're gonna have a bad time!)

URL Here: !!!error: Indecipherable SUB-paragraph formatting!!!

DISCUSSION (32)

Cherry_man1 > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:26

How can one be added to this list?

ddavidn > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:27

I doubt Automatch did that... I'll try and fix it later if nobody gets to it.

The Jevans > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:27

Also, someone needs to share this with me.

Tom McParland > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:28

Was trying to fix it but it looks like someone did it for me. If it was you good job. :)

KusabiSensei - Captain of the Toronto Maple Leafs > ddavidn
12/03/2013 at 11:29

I already did.

You should be *CLOSE* now to where you originally put things, now that ALL the columns are sorted, so the rows all stay together.

You'll want to check your own row.

KusabiSensei - Captain of the Toronto Maple Leafs > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:29

URL to the spreadsheet:

https://docs.google.com/spreadsheet/cc…

Tom McParland > The Jevans
12/03/2013 at 11:29

https://docs.google.com/spreadsheet/cc…

Tom McParland > Cherry_man1
12/03/2013 at 11:30

Just drop yourself on in...but just please be mindful of the input

https://docs.google.com/spreadsheet/cc…

KusabiSensei - Captain of the Toronto Maple Leafs > Tom McParland
12/03/2013 at 11:33

I did that. Because I figured you aren't me.

There's very few people with a Y chromosome who crush on Jake. :)

ddavidn > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:34

Could you be bothered to paste the link for a fellow opponaut?

Demon-Xanth knows how to operate a street. > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:34

Repaired my entries

Tom McParland > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:35

I have no idea what you are talking about with that last sentence but I'm glad all is fixed. :)

KusabiSensei - Captain of the Toronto Maple Leafs > ddavidn
12/03/2013 at 11:36

It's in the thread elsewhere, but for posterity:

https://docs.google.com/spreadsheet/cc…

DocWalt > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:37

I've added myself to that sheet probably 3 times now. I give up.

Cherry_man1 > Tom McParland
12/03/2013 at 11:38

*Realizes he hasn't used a spread sheet like this and doesn't want to fuck up* Um....how does one add themselfs ^^;

ddavidn > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:39

Oh God. It says I like Emma Stone. I hate Emma Stone... my row from mods —> is offset by two rows down (I have the crappy exhaust and the Toyota...)

Tom McParland > Cherry_man1
12/03/2013 at 11:40

Just drop in your stuff on the last row...the sort functions will put you were you need to be. :)

KusabiSensei - Captain of the Toronto Maple Leafs > Tom McParland
12/03/2013 at 11:42

Geez, biology jokes not appreciated?

Kinja'd!!!

Tom McParland > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:42

Nah...just over my head.

KusabiSensei - Captain of the Toronto Maple Leafs > ddavidn
12/03/2013 at 11:43

Yeah, it's because extra columns were added at some point, and not added to the filter.

Filters create column sets which are handled as discrete records when doing reordering. Excel does the same shit, but always moves the whole row.

KusabiSensei - Captain of the Toronto Maple Leafs > DocWalt
12/03/2013 at 11:44

The hard part is trying to add something when everyone else is doing it too.

KusabiSensei - Captain of the Toronto Maple Leafs > Tom McParland
12/03/2013 at 11:44

They do *now* ...

DocWalt > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:46

It saved and I went back and checked. People must just leave the tab open in their browser for days and mess stuff up. Oh well.

MonkeePuzzle > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:48

my line appears to be gone completely... do... do you guys not like me anymore!?

KusabiSensei - Captain of the Toronto Maple Leafs > MonkeePuzzle
12/03/2013 at 11:49

The problem stems from adding columns, but not to the sort column set.

Do add yourself again, and hopefully GDocs will not be stupid when doing sorts anymore.

Tom McParland > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:53

I've been looking for someone to maintain the list, because I always forget to check it. Would you mind keeping an eye on it every once and awhile?

Nibbles > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 11:54

Not quite yet. My lines (354-356) are not right. A354:F354 should be on row 351, A355:F355 on 352, A356:F356 on 350

I could attempt to fix but I'm afraid of losing Naija's, mykepagan's and Nerd-Vol's rides.

KusabiSensei - Captain of the Toronto Maple Leafs > Nibbles
12/03/2013 at 11:55

As long as you swap and don't delete, it should eventually find its way back.

If everyone checks, that is.

KusabiSensei - Captain of the Toronto Maple Leafs > Tom McParland
12/03/2013 at 12:00

An eye might be difficult, seeing as I have two of them.

I'll keep two eyes on it.

MonkeePuzzle > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 12:03

LETS BE FRIENDS!!!

!!! UNKNOWN CONTENT TYPE !!!

911e46z06 > KusabiSensei - Captain of the Toronto Maple Leafs
12/03/2013 at 17:12

Ugh. My M3 now has a 325i motor. And my Porsche has dual flowmasters. And my Corvette has a cattle guard and Hellas. And my Bronco has Potenza Pole Positions and Forgestar F14s. What a mess.

KusabiSensei - Captain of the Toronto Maple Leafs > 911e46z06
12/03/2013 at 19:17

Yeah, it was a mess.

I figured by the time the celebrity crushes got all mixed up, it was time to blow the whistle on it.

#WeGottaHaveStandardsPeople